SaPrintRegBillReportWork

Logical Entity Name | SaPrintRegBillReportWork
Default Table Name | SaPrintRegBillReportWork
Physical Only | NO
Owner | dbo
Definition |
Note |

SaPrintRegBillReportWork Columns

ColumnName | Domain | Datatype | NULL | Definition
SaPrintRegBillReportWorkID |  | int | NO |
BatchId |  | varchar(32) | YES |
RepType |  | char(1) | YES |
SyStudentID |  | int | YES |
StuNum |  | varchar(30) | YES |
StudentName |  | varchar(376) | YES |
NameStudent |  | nvarchar(376) | YES |
StudentAddr |  | varchar(255) | YES |
StudentCity |  | varchar(25) | YES |
StudentState |  | varchar(25) | YES |
StudentZip |  | varchar(25) | YES |
StudentPhone |  | varchar(25) | YES |
SchoolName |  | varchar(75) | YES |
SchAddr |  | varchar(255) | YES |
SchCity |  | varchar(25) | YES |
SchState |  | varchar(25) | YES |
SchZip |  | varchar(25) | YES |
CampusPhone |  | varchar(25) | YES |
AdEnrollID |  | int | YES |
AdEnrollIDConnect |  | int | YES |
PrintID |  | nvarchar(30) | YES |
ProgramVersion |  | nvarchar(150) | YES |
ExpStartDate |  | datetime | YES |
ArBalance |  | money | YES |
ProgramVersionConnect |  | nvarchar(150) | YES |
GradDate |  | datetime | YES |
EstimatedFunding |  | money | YES |
ExpStartDateConnect |  | datetime | YES |
Charges |  | money | YES |
PendingCharges |  | money | YES |
GradDateCOnnect |  | datetime | YES |
SyCampusID |  | int | YES |
StudentStatusCode |  | varchar(10) | YES |
StudentStatusDescrip |  | varchar(100) | YES |
PrintOverallBalance |  | bit | YES |
PrintClassSchedule |  | bit | YES |
PrintPaymentDueDate |  | bit | YES |
PaymentDueDate |  | datetime | YES |
PrintAddDropDate |  | int | YES |
AddDropDate |  | datetime | YES |
PrintExpFunding |  | bit | YES |
ExpFundingTermCode |  | varchar(50) | YES |
ExpFundingTerm |  | nvarchar(200) | YES |
StatementComment |  | varchar(500) | YES |
RegistrationComment |  | varchar(500) | YES |
PrintStudentAddress |  | bit | YES |
PrintEnrollmentInfo |  | bit | YES |
Addr1 |  | varchar(255) | YES |
City |  | varchar(25) | YES |
State |  | varchar(25) | YES |
Zip |  | varchar(25) | YES |
Country |  | varchar(50) | YES |
ScheduleAdTermID |  | int | YES |
Term |  | varchar(100) | YES |
StartDate |  | datetime | YES |
AdTermID |  | int | YES |
BillingMethod |  | varchar(10) | YES |
BillingMethodDescrip |  | varchar(100) | YES |
PrintLedgerCard |  | bit | YES |
PrintSubsidiary |  | bit | YES |
AcctStatus |  | varchar(100) | YES |
CreditCardList |  | varchar(500) | YES |
PmtPerDates |  | varchar(100) | YES |
FaStudentAyPaymentPeriodId |  | int | YES |
TotalAid |  | money | YES |
TotalCharges |  | money | YES |
PmtPerDatesConnect |  | varchar(100) | YES |
AcctStatusConnect |  | varchar(100) | YES |
FaStudentAyPaymentPeriodIdConnect |  | int | YES |
TotalPayments |  | money | YES |
TotalDiscounts |  | money | YES |
TotalPendingCharges |  | money | YES |
SaBillingStatementBatchStudentID |  | int | YES |
AdTermList |  | varchar(8000) | YES |
TransDate |  | varchar(50) | YES |
CurrencySymbol |  | varchar(10) | YES |
CurrencySymbolPosition |  | tinyint | YES |
SySchoolName |  | varchar(255) | YES |
CampusDescrip |  | varchar(100) | YES |
PrintIDonReport |  | varchar(20) | YES |
CampusDescripConnect |  | varchar(100) | YES |
StudentStatusCodeConnect |  | varchar(255) | YES |
StudentStatusDescripConnect |  | varchar(255) | YES |
BillingMethodConnect |  | varchar(255) | YES |
BillingMethodDescripConnect |  | varchar(255) | YES |
DateAdded |  | datetime | NO |
DateLstMod |  | datetime | NO |
UserId |  | int | NO |
ts |  | timestamp | NO |
FromTransDate |  | datetime | YES |
ToTransDate |  | datetime | YES |
AdTermGroupID |  | int | YES |
ExpFundingAdTermID |  | int | YES |

SaPrintRegBillReportWork Primary and Unique Keys

Key Name | Key Type | Keys
PK__SaPrintR__C72DB0C6FCA88C3D | PrimaryKey | SaPrintRegBillReportWorkID

SaPrintRegBillReportWork Foreign Keys

Parent Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication

Child Relationships:

Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication

SaPrintRegBillReportWork Check Constraints

Check Constraint Name | CheckConstraint

SaPrintRegBillReportWork Storage

STORAGE OPTION | STORAGE VALUE
Filegroup | PRIMARY
Text Image File Group |

SaPrintRegBillReportWork Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.SaPrintRegBillReportWork | NO |  |  |
Physical (Microsoft SQL Server) dbo.SaPrintRegBillReportWork | NO |  |  |

SaPrintRegBillReportWork Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model

SaPrintRegBillReportWork Data Movement Rules

Name | Type | Rule Text/Value